For easier querying and reporting, use the vFRParticipantTeamCaptain view, which unites team, team captain, and participant information. The view is created when you install Friendraising, and it contains the following columns:
■ ID
■ Meeting
■ Team ID
■ Team Name
■ Team Type
■ Team Goal
■ Captain ID
To report on this information, create a Team Participation query based on a business object that uses this view.
To create the Team Participation report
1. Create the new business object.
□ From Tools > Business object designer, select New > Design Business Definition.
□ Name the object FriendraisingTeamInfo.
□ Click Create Object.
□ Select the Database tab.
□ From the Tables section, click Add.
□ Select the vFRParticipantTeamCaptain view and click OK.
□ The Available Columns section is updated to list the view's fields.
□ From the Available Columns list, select the fields you want to be listed as Properties of the business object and then click Add as Properties. The properties are added in the order you select them. Or you can Add All as Properties. If you add all fields as properties, the properties are added in alphabetical order.
□ Click Save and then Publish.
2. Define a query using the new business object.
3. Create a report using the new query.